package org.example.equip.controller;

import cn.hutool.core.util.StrUtil;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.listener.PageReadListener;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.commons.common.Result;
import com.example.commons.entity.Equip;
import com.example.commons.entity.Suit;
import com.example.commons.entity.dto.EquipStats;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.tags.Tag;
import jakarta.annotation.Resource;
import jakarta.servlet.http.HttpServletResponse;
import org.example.equip.service.EquipService;
import org.example.equip.service.SuitService;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.net.URLEncoder;
import java.util.Arrays;
import java.util.List;

/**
 * @program: authority-v3.0.7
 * @ClassName:EquipController
 * @description: EquipController前端控制器
 * @author:dyy
 * @Version 3.0
 **/

@Tag(name = "套装列表 前端控制器")
@RestController
@RequestMapping("/suit")
public class SuitController {
    @Resource
    private SuitService suitService;


    /**
     * 新增
     *
     * @param suit
     * @return
     */
    @Operation(summary = "新增")
    @PostMapping
    public Result save(@RequestBody Suit suit) {
        return Result.success(suitService.save(suit));
    }


    /**
     * 修改
     *
     * @param suit
     * @return
     */
    @Operation(summary = "修改")
    @PutMapping("/{id}")
    public Result update(@PathVariable Long id, @RequestBody Suit suit) {
        return Result.success(suitService.updateById(suit));
    }


    /**
     * 查询所有Suit
     *
     * @return
     */
    @Operation(summary = "查询所有Suit")
    @GetMapping
    public Result findAll() {
        return Result.success(suitService.list());
    }

    /**
     * 查询套装列表
     *
     * @return
     */
    @Operation(summary = "查询套装列表")
    @GetMapping("/list")
    public Result listSuits(@RequestParam(required = false) String name) {
        LambdaQueryWrapper<Suit> wrapper = new LambdaQueryWrapper<>();
        if (StrUtil.isNotBlank(name)) {
            wrapper.like(Suit::getName, name);
        }
        wrapper.select(Suit::getId, Suit::getName);
        return Result.success(suitService.list(wrapper));
    }


    /**
     * 获取单个
     *
     * @param id
     * @return
     */
    @Operation(summary = "获取单个")
    @GetMapping("/{id}")
    public Result findOne(@PathVariable Long id) {
        return Result.success(suitService.getById(id));
    }


    /**
     * 分页显示
     *
     * @param
     * @param pageNum
     * @param pageSize
     * @return
     */
    @Operation(summary = "分页显示")
    @GetMapping("/page")
    public Result findPage(
            @RequestParam(defaultValue = "") String name,
            @RequestParam(required = false) Integer grade,
            @RequestParam(defaultValue = "1") Integer pageNum,
            @RequestParam(defaultValue = "10") Integer pageSize) {

        LambdaQueryWrapper<Suit> queryWrapper = new LambdaQueryWrapper<>();
        if (StrUtil.isNotEmpty(name)) {
            queryWrapper.like(Suit::getName, name);
        }
        if (grade != null) {
            queryWrapper.eq(Suit::getGrade, grade);
        }
        queryWrapper.orderByDesc(Suit::getId);
        return Result.success(suitService.page(new Page<>(pageNum, pageSize), queryWrapper));
    }


    /**
     * 单个删除
     *
     * @param id
     * @return
     */
    @Operation(summary = "单个删除")
    @DeleteMapping("/{id}")
    public Result delete(@PathVariable Long id) {
        return Result.success(suitService.removeById(id));
    }


    /**
     * 批量删除
     *
     * @param ids
     * @return
     */
    @Operation(summary = "批量删除")
    @DeleteMapping("/batch/{ids}")
    @Transactional
    public Result deleteByIds(@PathVariable String[] ids) {
        return Result.success(suitService.removeByIds(Arrays.asList(ids)));
    }


    /**
     * 批量导出
     * 使用的技术为alibaba下面的easyexcel
     * 写数据
     *
     * @param ids
     * @return
     */
    @Operation(summary = "批量导出")
    @GetMapping("/batch/export/{ids}")
    public void exportByIds(@PathVariable String[] ids, HttpServletResponse response) throws IOException {
        List<Suit> list = suitService.listByIds(Arrays.asList(ids));

        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setCharacterEncoding("utf-8");

        String fileName = URLEncoder.encode("suit导出数据", "UTF-8").replaceAll("\\+", "%20");
        response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
        EasyExcel.write(response.getOutputStream(), Suit.class).sheet("sheel1").doWrite(list);
    }


    /**
     * 批量导入
     * 使用的技术为alibaba下面的easyexcel
     * 读数据
     *
     * @param
     */
    @Operation(summary = "批量导入")
    @PostMapping("/batch/upload")
    public Result writeExcel(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), Suit.class, new PageReadListener<Suit>(dataList -> {
            dataList.forEach(entity -> suitService.save(entity.toBuilder().id(null).build()));
        })).sheet().doRead();
        return Result.success();
    }
}